if exists (select 1
            from  sysobjects
           where  id = object_id('bd_nianjia')
            and   type = 'U')
   drop table bd_nianjia
go

/*==============================================================*/
/* Table: bd_nianjia                                            */
/*==============================================================*/
create table bd_nianjia (
   user_serial          varchar(50)          not null,
   fdnjts               int                  not null default 0,
   flnjts               int                  not null default 0,
   sdjqts               int                  not null default 0,
   txts                 int                  not null default 0,
   txsx                 int                  not null default 0,
   lastfdnj             int                  not null default 0,
   lastflnj             int                  not null default 0,
   njcount              int                  not null default 0,
   txcount              int                  not null default 0,
   sdnj                 int                  not null default 0,
   sdtx                 int                  not null default 0,
   real_txts            int                  not null default 0,
   sdsxsj               date                 null,
   constraint PK_BD_NIANJIA primary key (user_serial)
)
go
